package com.csdj.mapper;

import com.csdj.pojo.PyBill;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Param;

/**
* @author 叶涵
* @description 针对表【py_bill】的数据库操作Mapper
* @createDate 2023-08-24 15:13:39
* @Entity com.csdj.pojo.PyBill
*/
public interface PyBillMapper extends BaseMapper<PyBill> {

    /**
     * 本月应收水费
     * @return
     */
    Double selectThisMonthTotalWaterFee(@Param("year") int year,@Param("month")int month);
    /**
     * 本月实收水费
     * @return
     */
    Double selectThisMonthActualWaterFee(@Param("year") int year,@Param("month")int month);
}




